home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / truncate.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  254 b   |  12 lines  |  [TEXT/ttxt]
  1. #
  2. # Test of truncate
  3. #
  4. create table t1 (a integer, b integer,c1 CHAR(10));
  5. truncate table t1;
  6. select count(*) from t1;
  7. insert into t1 values(1,2,"test");
  8. select count(*) from t1;
  9. drop table t1;
  10. # The following should fail
  11. !$1146 select count(*) from t1;
  12.